/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1809

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00000010| 4e 55 4c 4c 00 20 20 20 | 20 2d 2d 20 45 52 77 69 |NULL.   | -- ERwi|
|00000020| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00000030| 69 6d 65 20 0d 0a 20 20 | 20 20 2d 2d 20 25 50 61 |ime ..  |  -- %Pa|
|00000040| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00000050| 20 25 43 68 69 6c 64 20 | 4f 4e 20 43 48 49 4c 44 | %Child |ON CHILD|
|00000060| 20 49 4e 53 45 52 54 20 | 53 45 54 20 4e 55 4c 4c | INSERT |SET NULL|
|00000070| 20 0d 0a 20 20 20 20 75 | 70 64 61 74 65 20 25 43 | ..    u|pdate %C|
|00000080| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 73 65 74 0d |hild..  |    set.|
|00000090| 0a 20 20 20 20 20 20 20 | 20 2d 2d 20 25 25 53 65 |.       | -- %%Se|
|000000a0| 74 46 4b 28 25 43 68 69 | 6c 64 2c 4e 55 4c 4c 29 |tFK(%Chi|ld,NULL)|
|000000b0| 20 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 | ..     |   %SetF|
|000000c0| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|000000d0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 |      wh|ere..   |
|000000e0| 20 20 20 20 20 6e 6f 74 | 20 65 78 69 73 74 73 20 |     not| exists |
|000000f0| 28 0d 0a 20 20 20 20 20 | 20 20 20 20 20 73 65 6c |(..     |     sel|
|00000100| 65 63 74 20 2a 20 66 72 | 6f 6d 20 25 50 61 72 65 |ect * fr|om %Pare|
|00000110| 6e 74 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |nt..    |        |
|00000120| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. |        |
|00000130| 20 20 20 20 20 2d 2d 20 | 25 25 4a 6f 69 6e 46 4b |     -- |%%JoinFK|
|00000140| 50 4b 28 25 4e 65 77 2c | 25 50 61 72 65 6e 74 2c |PK(%New,|%Parent,|
|00000150| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 0d 0a |" = "," |and") ..|
|00000160| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a |        |      %J|
|00000170| 6f 69 6e 46 4b 50 4b 28 | 25 4e 65 77 2c 25 50 61 |oinFKPK(|%New,%Pa|
|00000180| 72 65 6e 74 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rent," =| "," and|
|00000190| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 29 20 61 6e |")..    |    ) an|
|000001a0| 64 0d 0a 20 20 20 20 20 | 20 20 20 25 46 6f 72 45 |d..     |   %ForE|
|000001b0| 61 63 68 46 4b 41 74 74 | 28 22 20 61 6e 64 20 22 |achFKAtt|(" and "|
|000001c0| 29 20 7b 0d 0a 20 20 20 | 20 20 20 20 20 25 43 68 |) {..   |     %Ch|
|000001d0| 69 6c 64 2e 25 41 74 74 | 46 69 65 6c 64 4e 61 6d |ild.%Att|FieldNam|
|000001e0| 65 20 3d 20 25 4e 65 77 | 2e 25 41 74 74 46 69 65 |e = %New|.%AttFie|
|000001f0| 6c 64 4e 61 6d 65 7d 3b | 0d 0a 00 1a 27          |ldName};|....'   |
+--------+-------------------------+-------------------------+--------+--------+